Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |