Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
)
}
Solved! Go to Solution.
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]
)
)
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]
)
)
Hi @ncbshiva,
Kindly share your sample data and excepted result to me.
Regards,
Frank
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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |