How do i create this DAX table in Power Query

LINUS_MAASTOK

New Member
Joined
Oct 25, 2019
Messages
11
I every one, i have a problem...

I have created a table in dax, like this

Code:
NISCountLT2 = SUMMARIZECOLUMNS(LT2[ID]; "Total"; COUNT(LT2[ID]))
to count repeated IDs

then i use this code to create a column with ranges for the report


Code:
Bucket Range = SWITCH( TRUE(); 
    NISCountLT2[Total]=1;"1";
    NISCountLT2[Total]<=2;"2";
    NISCountLT2[Total]<=3;"3";
    NISCountLT2[Total]<=4;"4";"5+")
it works fine, but when i need to work with it on Power Query PBI says "NO QUERY FOUND, please refresh the model to discard any stale data"

thats because i created the table in DAX... i need to create it on PQ , how do i do that? :confused:

BTW, excuse for my bad english
 

Forum statistics

Threads
1,077,822
Messages
5,336,564
Members
399,088
Latest member
Swindlestikz

Some videos you may like

This Week's Hot Topics

Top