The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have data until the end of 2022 but I want to present the data until today (May 2022)
this is my dax :
Cumulative ProjectTable =
VAR ABV = CALCULATE ( LASTDATE( ProjectTable[date] ))
RETURN
IF( SELECTEDVALUE('Date'[Date]) > TODAY(), BLANK(),
CALCULATE(COUNT(ProjectTable[id]), 'ProjectTable'[active] = 1,
FILTER( ALLSELECTED('Date'),
'Date'[Date] <= MAX('Date'[Date] ))))
But on visualization, it looks like this:
Which Dax do I need to take off the months of June 22 until December 22?
thanks all!
Solved! Go to Solution.
Hi @dolevh ,
Please refer to my pbix file to see if it helps you.
Create a measure.
_today=IF(MAX('Table'[date])>TODAY(),0,1)
Then put the measure into the filter.
Then the dates June 22 until December 22 were removed.
If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks to all its working 🙂
Hi @dolevh ,
Please refer to my pbix file to see if it helps you.
Create a measure.
_today=IF(MAX('Table'[date])>TODAY(),0,1)
Then put the measure into the filter.
Then the dates June 22 until December 22 were removed.
If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Add a new column to your date table to return true if the date is on or before TODAY(), then use that as a filter on the chart.
User | Count |
---|---|
12 | |
9 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
14 | |
9 | |
7 |