search

intakedesk / PowerBI-General

Placeholder for issues migrated from Jira
1 stars 0 forks source link

TV 2.0: Decommission Leads Date_entered column and Leave a measure concatenating date and time #499

Closed jesusitd closed 4 years ago

jesusitd commented 4 years ago

Created replacement Measure:

Lead Date Entered Datetime = 
IF(
    HASONEVALUE( Leads[lead_id] ),
    MAXX( Leads, Leads[date_entered_date] + Leads[date_entered_time] ),
    BLANK()
)

Initial size: 9.71 MB image

Initial Load: image

jesusitd commented 4 years ago

New size: 87551 KB image

Reduction 2.2%

Final state of PBIX Analyzer: image