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.
Solved! Go to Solution.
Hi Arul,
Measure = Calculate(Sum(Sales),Parallelperiod(Date,-1,Month))
Hope it will solve your prob ,
if not let me know
Hi Arul,
Measure = Calculate(Sum(Sales),Parallelperiod(Date,-1,Month))
Hope it will solve your prob ,
if not let me know
I have been trying this method, and also using previous month function on Power Bi Sample Financial Data , but have not been getting any values
Could you please help me troubleshoot these ?
What if the previous month is in the previous year. For example, I tried your formula but I have sales for January 2017 and I want to see sales for December 2016. For some reason the formula does not return a result when there were sales for that product in the previous period. Any suggestions?
is your data type set correctly?
Proud to be a Super User!
hai baskar,
Thank you very much .... Its more helpful for me
You can use the PREVIOUSMONTH function:
https://msdn.microsoft.com/en-us/library/ee634758.aspx
=CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), PREVIOUSMONTH('DateTime'[DateKey]))
Thanks,
Sam Lester (MSFT)
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 |