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 am struggling to get this going.
So I have a date column which contains all the dates from 2018 till today.
Now my requirement is
1) If the date is of current year, then months column= Date month- last month of current year.
For example - If Date is 30/05/2022 then Months column should output= 7
2) if the date is of previous years, then months column output should be 12.
For example - If date is 30/05/2018 or 25/09/2019 etc for all these output months column should always be 12.
Can anyone please help ?
Solved! Go to Solution.
@Saswa_D add this calculated column:
@Saswa_D add this calculated column:
Thank You, This worked perfectly.
@Saswa_D my pleasure 🙂 Happy to help.
Please check out my showcase report - got some high level stuff there..
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂
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 |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |