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 Team,
I need to calculated column for last 3 months from selected month.
for example, if we select "May", then result should is May, April, March.
Thanks in advance.
Hi @siva54
Do you want a table with one column that has three months from the selected month? If yes, you can use DATESINPERIOD and use SELECTEDVALUE as a start date.
But suppose you want a calculated column in your existed table to show last 3 months from the selected month. In that case, you can use the above code and filter to use that in a calculation or add a calculated column and say if a date is in the range, show one; otherwise, zero.
Read this link and add more details to your request:
Appreciate your Kudos✌️!!
Since there is no any filter context in the Calculated Column you will not be able to achive it based on a filter selection. As per above solution you can do it based on Todays value only.
Hi Kazun909,
For More clarification,
If i select May then in the table i need to see last three months data(only March, April, May).
we have year also.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |