Forum Discussion

femcoldt's avatar
femcoldt
Frequent Visitor
2 years ago

Need help with DAX

Hi everyone,  I am in a situation. the screen shot below is in excel, i have all the measures except for the ones in the red rectange. I am fighiting to get a way to calcualte this in powerbi.  ...
Need Help
femcoldt's avatar
femcoldt
Frequent Visitor
2 years ago

HI Anonymous Xiaoxin,

 

FInd attached a sample PBIX file from this link Master.pbix with some random dataset about my thoutght process.

 

I want to to the first three month in the year for F24 Act + Fcst divided by F24 Actual whihc is Jan to March and so on.

 

Thanks

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Share some dummy data in an Excel file and on another tab, show the expected results with your formulas.  I will try to translate those Excel formulas in the DAX language.  Share only as much data as is required to get those 3 calculations.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      There is no concept of cell merging in visuals.  Therefore, the workaround would be to insert quarter and half year columns and show the ro 14 and 15 calcultions under those columns.  If you are OK with my approach, then share the download link of the PBI file.