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.
Hello!
This year I started with PowerBI, i have about 2 years experience with QlikSense/View. So most of the challenges I could solve with my experience with Qlik. But now I just cant get it to work like I want, hope you can help!
I want to make the following measure: sum([Amount]) + sum(previousmonth([Amount]) from the FACT table. But when its january 2018 i dont want to sum the previous month 2017 december. So sum only if the previous month is in the current year.... In Qlik i would have done something like...if year from fact table matches the calendar year then sum amount + previousmonth amount.
how do i achieve this in PowerBI?
Solved! Go to Solution.
Hi @RH-BIP,
Please refer to this thread to use PREVIOUSMONTH function properly.
In your scenario, the IF statement could be similar to:
Measure = IF ( MONTH ( SELECTEDVALUE ( 'DateTime'[DateKey] ) ) <> 1, SUM ( Fact[Amount] ) + CALCULATE ( SUM ( Fact[Amount] ), PREVIOUSMONTH ( 'DateTime'[DateKey] ) ) )
For more advice, please provide sample data and desired result as suggested in this article.
Best regards,
Yuliana Gu
Hi @RH-BIP,
Please refer to this thread to use PREVIOUSMONTH function properly.
In your scenario, the IF statement could be similar to:
Measure = IF ( MONTH ( SELECTEDVALUE ( 'DateTime'[DateKey] ) ) <> 1, SUM ( Fact[Amount] ) + CALCULATE ( SUM ( Fact[Amount] ), PREVIOUSMONTH ( 'DateTime'[DateKey] ) ) )
For more advice, please provide sample data and desired result as suggested in this article.
Best regards,
Yuliana Gu
@v-yulgu-msft exactly what i needed!
Had to alter it a bit but this works, thank you!
Previous = SUM ( 'Fact table'[Amount] ) + IF ( MONTH ( SELECTEDVALUE ( 'Calender'[Jaar_maand] ) ) <> 1, CALCULATE ( SUM ( 'Fact table'[Amount] ), PREVIOUSMONTH ( 'Calender'[Datum] ) )
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |