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
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,095,752
Messages
5,446,294
Members
405,395
Latest member
anilals

This Week's Hot Topics

Top