Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
what is the correct data type for this formula? I have date as calendar and Amounts as mesure or Number of pages as number. I do not have any return. May youplease advise?
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)
User | Count |
---|---|
91 | |
77 | |
71 | |
64 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |