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
to count repeated IDs
then i use this code to create a column with ranges for the report
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?
BTW, excuse for my bad english
I have created a table in dax, like this
Code:
NISCountLT2 = SUMMARIZECOLUMNS(LT2[ID]; "Total"; COUNT(LT2[ID]))
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?
BTW, excuse for my bad english