The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I need to migrate MDX calculations (which we are using in SSAS Multidimentional mode.) Can you please help here to convert the same into DAX. Below is one of calculation in MDX.
Measure = SUM(PeriodsToDate([Time_Period].[Time_Period].[Period],[Time_Period].[Time_Period].CurrentMember),[Measures].[Hrs_Act_Admin_POS])
In above MDX we have used PeriodsToDate function. PeriodsToDate: about this function https://www.tutorialgateway.org/mdx-periodstodate-function/
can you please help here to create DAX query
Hi, @MMadhusudhan
Sorry, I'm not familiar with MDX, can you show your sample data and expected result?
Also please see if this thread below is useful to you.
Converting MDX calculations to DAX ( Inventory ending balance)
Best Regards,
Community Support Team _ Eason
@MMadhusudhan - do you want have a look at the time intelligence related function on Time Intelligence - DAX Guide There are also helpful video explaining these functions.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |