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 have a slicer that shows sales upto todays date in earlier month (eg. today it shows what we have sold each month upto the 18th):
Solved! Go to Solution.
Hi @sw123 ,
If Monthday=DAY(DateTable[Date]) is a measure,it should be modified as below:
Monthday=DAY(SELECTEDVALUE(DateTable[Date]))
If it doesnt work, pls show me your .pbix file.You can upload it to onedrive then share the link with us.
Hi, the easiest way, when your first formula works as expected, would be to replace the <= with <
Yesterdays date = if(DateTable[Monthday] < DAY(TODAY()); TRUE(); FALSE())
Thanx, but it still doesn't work. Does it have something to do with the Monthday, that is a measure in my date table:
Hi @sw123 ,
If Monthday=DAY(DateTable[Date]) is a measure,it should be modified as below:
Monthday=DAY(SELECTEDVALUE(DateTable[Date]))
If it doesnt work, pls show me your .pbix file.You can upload it to onedrive then share the link with us.
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |