Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am trying to create a table that compares the current months DAIs with the previous months. Example given below:
I am wanting the data to actively change - so when it's October the previous months is September and when the Current month turns to November, the previous month will change to October.
Thanks,
Dean
Solved! Go to Solution.
@deanbland please create the following two measures.... here's the DAX Code
Mes actual RAG - CALCULATE(FIRSTNONBLANK('Table'[RAG Status],TRUE()),FILTER('Table',MONTH('Table'[Report Date])-MONTH(TODAY())))
Rag del mes anterior - CALCULATE(FIRSTNONBLANK('Table'[RAG Status],TRUE()),FILTER(ALLEXCEPT('Table','Table'[DAI]),MONTH('Table'[Report Date])-MONTH(TODAY())-1))
This will give you the required output as below screenshot shown
Please accept this as a solution if this resolved your query!! Appeciate kudos also 😀
@deanbland please create the following two measures.... here's the DAX Code
Mes actual RAG - CALCULATE(FIRSTNONBLANK('Table'[RAG Status],TRUE()),FILTER('Table',MONTH('Table'[Report Date])-MONTH(TODAY())))
Rag del mes anterior - CALCULATE(FIRSTNONBLANK('Table'[RAG Status],TRUE()),FILTER(ALLEXCEPT('Table','Table'[DAI]),MONTH('Table'[Report Date])-MONTH(TODAY())-1))
This will give you the required output as below screenshot shown
Please accept this as a solution if this resolved your query!! Appeciate kudos also 😀
Works a treat, thank you!
Have you tried using DateAdd(...-1,Month) or EDATE(-1) in your DAX?
Unsure how to action this... I am relitively new to Power BI!
I have produced a mock-up table below, what would the DAX formula be/ what steps would I need to carry out?
The ideal scenario would be to add a column that shows as true or false (true when the date is one month ago and false for any other date).
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |