Hej Jeg har tidligere oprette denne tråd ( old discussion ), hvor jeg har bygget en query der kan trække data fra energinet. Det har vist sig, at der er en del der godt vil bruge den. Jeg oplever dog at den er ustabil og vil derfor gerne bygge en custom ...
Hi Fu Chen. Don't know if you got this solved. I had the same issue, RLS was fine in PowerBI Service, but user could see everything in excel. Solution for me was: 1: Add user in workspace access with VIEWER rights 2. On the specific dataset in the workspace, ...
Hi, I believe I have solved the problem.
The solution that did the trick was not a calculated column, but a Power Query column.
Thanks to Mynda Treacy from Myonlinetraininghub for this example:
I have searched in wain for similar problems, but in wain.
I have this table:
I need a calculated ...
OK... by picking the intervals between the numbers, I could see that all results were divisible by 24. 24hrs!!! Multiply the 0,817847222 by 24 and we get 19.62833. Multiply any of the decimals by 24 and subtract the constant 0.62833 and you get the ...