Forum Discussion

Frequent Visitor

5 years ago

Solved

calculating run rate

Hi all, I am new to Power Bi and this may seem like nothing but, I am stuck on a problem and I have no idea how to proceed further with it. So I have live sales data for the 90 days from which I hav...

General Comment

Need Help

Icey
5 years ago
Hi beast314 ,

My previous measure works in this sample. Do I miss anything?

Note: I didn't return any value for year level in the Matrix value, because I don't know your calculation logic for year.

Best Regards,

Icey
RR1.pbix38 KB

Icey

Community Support

5 years ago

Hi beast314 ,

Could you create a sample .pbix with the same data and model structure for me to test? Maybe there is something missing in my sample above.

For your data security, please don't use real data or contain any sensitive information in the sample .pbix file.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

beast314

Frequent Visitor

5 years ago

https://drive.google.com/file/d/1expali_JN2VePfdyijyjFoEL29udjNdd/view?usp=sharing

Here is a sample dataset. Note that I want a 30-day average region-wise.

Icey
Community Support
5 years ago
Hi beast314 ,

My previous measure works in this sample. Do I miss anything?

Note: I didn't return any value for year level in the Matrix value, because I don't know your calculation logic for year.

Best Regards,

Icey
RR1.pbix38 KB

Forum Discussion

calculating run rate

Related content

Calculate Run Rate

Calculating run rate

Calculate Alarm Rate

DAX Measure for Ranking the valid rows and calculating the average rating

Utilization Rate