Forum Discussion
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 ?
{FIXED
[Dstr Name],[Product description],YEAR([Day Date]), MONTH([Day Date])
:
COUNTD(
IF
[Fulls (Crates or Hl)]>0
THEN
[Product description]
END
)
}
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]
)
)
6 Replies
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
Hello,
Can anyone help me to convert from Tableau LOD to DAX .
FIXED
[Dstr Name],[Product description],YEAR([Day Date]), MONTH([Day Date])
:
COUNTD(
IF
[Fulls (Crates or Hl)]>0
THEN
[Product description]
END
)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]
)
)
