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.
I need to have the output like this in dax. The table shows different students and there status in each term i want to calulate the output for their status in term they last appear here T1, T2,T3 ,T4 and T5 are different terms and the output is the required one let me know what will be Dax querries to grab last value in the term they appear.
Solved! Go to Solution.
@u4unnicool in case you mean a calculated column in the model table then:
output =
SWITCH(
TRUE(),
'Table'[T5] <> "" ,'Table'[T5],
'Table'[T4] <> "" ,'Table'[T4],
'Table'[T3] <> "" ,'Table'[T3],
'Table'[T2] <> "",'Table'[T2],
'Table'[T1] <> "",'Table'[T1]
)
@u4unnicool in case you mean a calculated column in the model table then:
output =
SWITCH(
TRUE(),
'Table'[T5] <> "" ,'Table'[T5],
'Table'[T4] <> "" ,'Table'[T4],
'Table'[T3] <> "" ,'Table'[T3],
'Table'[T2] <> "",'Table'[T2],
'Table'[T1] <> "",'Table'[T1]
)
@SpartaBI your solution worked thank you i added null as blank
=
SWITCH(
TRUE(),
'Table'[status T5] <> BLANK() ,'Table'[status T5],
'Table'[status T4] <> BLANK() ,'Table'[status T4],
'Table'[status T3] <> BLANK() ,'Table'[status T3],
'Table'[status T2] <> BLANK(),'Table'[status T2],
'Table'[status T1] <> BLANK(),'Table'[status T1]
)
@u4unnicool my pleasure 🙂
Hey, check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |