Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I guess this was asked several times but I still wasn't able to find a solution to my query.
I have a set of data that is being updated randomly and not on a daily basis (otherwise it was easy).
I need to let my users know what is the latest DATE that dataset is referring to.
For example if they are pulling the data on January 5, 2018 they should be able to know that the data is up-to-date as of 04/01/2018, or if they pull the data a couple of days later on January 10, 2018, it should be noted that the data is as of 07/01/2018.
I tried to build a function using MAX but was not able to nail this.
Any help would be highly appreciated.
Thanks,
NH
Solved! Go to Solution.
Hi @nhol,
I have two approaches that are all measures. Please try them out.
Measure 1 = CALCULATE ( LASTDATE ( 'Table1'[Date] ), ISBLANK ( 'Table1'[Sales] ) = FALSE () )
Measure 2 = LASTNONBLANK ( 'Table1'[Date], CALCULATE ( SUM ( 'Table1'[Sales] ) ) )
Best Regards,
Dale
Hi NH,
Try this formula as a calculated column please.
Column = CALCULATE ( LASTDATE ( 'Table1'[Date] ), FILTER ( 'Table1', ISBLANK ( 'Table1'[Sales] ) = FALSE () ) )
Best Regards,
Dale
Hi @nhol,
I have two approaches that are all measures. Please try them out.
Measure 1 = CALCULATE ( LASTDATE ( 'Table1'[Date] ), ISBLANK ( 'Table1'[Sales] ) = FALSE () )
Measure 2 = LASTNONBLANK ( 'Table1'[Date], CALCULATE ( SUM ( 'Table1'[Sales] ) ) )
Best Regards,
Dale
Thanks! Both of them work.
What would it be if I want to use a column and not a measure?
NH
Hi NH,
Try this formula as a calculated column please.
Column = CALCULATE ( LASTDATE ( 'Table1'[Date] ), FILTER ( 'Table1', ISBLANK ( 'Table1'[Sales] ) = FALSE () ) )
Best Regards,
Dale
Thank you Dale!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |