Forum Discussion
Power BI DAX
=num( sum({<forecast_type={'dispatches-fcst_ship'},cm={'1'},intercompany_flag=,fiscalmonth=,fiscalquarter=,fiscalyear=>}FORECAST_AMOUNT) ,'#,##0')
What will this QlikView calculation be in Power BI?
Hi Anonymous ,
It is because that you are filtering "fact_all" table,but you wanna get the {cm} value which is in "Master_Calendar" table,you'd better use "lookupvalue()"function or "related()" function.
Below are the references:
https://dax.guide/lookupvalue/
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
11 Replies
Hi Anonymous ,
Try this measure
Measure=
var a = CALCULATE (SUM (Table [FORECAST AMOUNT]) , FILTER (Table, Table [Forecast_Type] = "dispatches-fcst_ship" && Table [CM] = 1))
RETURN
FORMAT(a,"#,##0")
Pull the Date from the Date Table and this measure.
The row context will take care of the sums by Fiscal Dates.
Regards,Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!