Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to make a measure with filter but dont works:
Solved! Go to Solution.
Hi,
As long as the Calendar table has been created using the CALENDAR() function, the formula should always return the value of the last date in the Calendar Table (which in turn should pick up the last date from the Data Table).
Hope this helps.
Hi,
Create a Calendar Table with a relationship (Many to One and Single) from the F_Valor column to the Date column of the Calendar Table. Try this measure
Thx Ashish, I have the calendar table, and his measure works, but How can I add the filter the MaxDate? this is beacuse daily the data update wiht the previous date .
Hi,
As long as the Calendar table has been created using the CALENDAR() function, the formula should always return the value of the last date in the Calendar Table (which in turn should pick up the last date from the Data Table).
Hope this helps.