Forum Discussion
Solved
From Tableau Fixed function to Power BI DaX
Hi , I am trying to move my reports from Tableau to Power BI and i have some below LOD function which should be written in DAX. Can any one please help to convert Tableau LOD to Power BI DAX ? ...
How about this:
-> Add 2 new column to the table:
Year = YEAR('Table'[day_date]) Month = MONTH('Table'[day_date])-> Create a measure as below:
Measure =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Product Description] ),
'Table'[Full(Crates & HL)] > 0,
ALL ( 'Table'[day_date] ),
SUMMARIZE (
'Table',
'Table'[Dstr Name],
'Table'[Product description],
'Table'[Year],
'Table'[Month]
)
)
| Dstr Name | Product Description | day_date | Full(Crates & HL) |
| A | Cola | 14-9-2017 | 28989 |
| A | Pepsi | 21-8-2018 | 765 |
| B | Fanta | 1-4-2018 | 631 |
| B | Amstel | 5-12-2017 | 7633 |
Hi This is just the sample data ,
Hi ncbshiva,
To use this measure.
Measure = CALCULATE(DISTINCTCOUNT(Table1[Product Description]),FILTER(Table1,Table1[Full(Crates & HL)]>0))
For more details, please check the pbix as attacched.
Regards,
Frank
Hi Frank ,
Thanks for ur reply, i got the distinct count number . But they have used FIXED LOD calcualtions in Tableau.
How can i use the same in Power BI DAX ?