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.
I want to compare values between last date and second last date. The date table has future dates as well so I am filtering the date with the non null FactCovidADCDaily[Daily Census (Total)] value. Here is my DAX:
Hi @monikamishra ,
On the second last date you are picking up all the dates except the max date however since you are getting the full values of the table you always get the same values.
I don't know how you have your information but the second last date can be picked up with something similar to:
Second Last Date =
MAXX (
FILTER (
ALLSELECTED(FactCovidADCDaily);
FactCovidADCDaily[Daily Census (Total)] <> BLANK ()
&& FactCovidADCDAily[Date] < MAX ( DimDate[Date] )
);FactCovidADCDaily[Date]
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |